Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
SalesRestrictionTypeCode (FK)(PK) | A unique, automatically assigned code for a specific limitation on an ITEM's sale. | TY_RST_SLS | Code4 | char(4) | |
TimeGroupID (FK) | A unique identifier for a set of consecutive hours on a set of days of the week. e.g. 10am - 2pm Mon, Wed and Fri. | ID_GP_TM | Identity | integer | TimeGroup(CO_GP_TM) |
StartDayOfWeekCode | A code to denote the start date in the week for the item sales restriction. | WD_SRT_RST | DateWeekdayISO8061 | char(1) | |
EndDayOfWeekCode | A code to denote the end date in the week for the item sales restriction. | WD_END_RST | DateFiscalDay | char(1) | |
StartTime | A code to denote the start time on a specified day for the item sales restriction. | TM_SRT_RST | Time | Time | |
EndTime | A code to denote the end time on a specified day for the item sales restriction. | TM_END_RST | Time | Time | |